Entity DefinitionLogical Name : FuelPump |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
| FuelPumpID (PK) | A unique identifier for the FuelPump | ID_FUEL_PMP | Identity | integer | |
| EquipmentID (FK) | The fixed asset number assigned by the retailer for this particular piece of equipment. | ID_EQ | Identity | integer | Equipment(AS_EQ) |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| RetailStore | houses | FuelPump |
| Equipment | is a | FuelPump |
| FuelPump | houses | FuelingPoint |
| Logical View |
|---|
| Logical 06400 - Store Equipment View |
| Logical 20000 - Forecourt Macro View |
| Logical 20010 - Forecourt Fueling Point View |